//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Copyright 2007 CORE Solutions Limited
// All rights reserved.
// PROPRIETARY AND CONFIDENTIAL INFORMATION.
// Use is subject to license terms.
//
// FUNCTION ID      :   MASTER_DEPARTMENT
// AUTHOR           :   Ray Guo 
// DATE CREATE      :   2007/07/11
// DESCRIPTION      :   a SCHEMA file for the function, MASTER_DEPARTMENT
//                  :   
//                  :   
//                  :   
//
// MODIFICATION HISTORY:
// DATE         AUTHOR          VERSION NO.         COMMENT
// -----------  --------------  ------------------  -------------------
// 2007/07/11   Ray Guo         1.0                 source is generated.
//
//
//
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

package com.erp.app.setup.dept.schema;

import com.erp.framework.model.schema.MetaData;
import com.erp.framework.model.schema.TableSchema;

/**
* <p>A <strong>Schema</strong> stores the table meta information.
* The main purpose for this class is to validate the lengths of UniCode Characters,
* and notify the database to store UniCode characters from web browsers.
*
* @author          Ray Guo 
* @version 1.0     2007/07/11
* @since           FrameWork 1.0
*
*/
public class DeptHdrSchema extends TableSchema {

	public static final String TABLE_NAME = "T_DEPT_HDR";

	public DeptHdrSchema(){

		MetaData md = null;

		md = new MetaData();
		md.setColumnName("COMPANY_CODE");
		md.setVoPropertyName("companyCode");
		md.setColumnTitle("COMPANY_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_DEPARTMENT_COMPANY_CODE");
		md.setWebLabelName("DEF DEPARTMENT COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_COMPANY_CODE");
		md.setVoPropertyName("srchCompanyCodeFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_COMPANY_CODE");
		md.setWebLabelName("DEF SRCH COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_COMPANY_CODE");
		md.setVoPropertyName("srchCompanyCodeTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_COMPANY_CODE");
		md.setWebLabelName("DEF SRCH COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_COMPANY_CODE");
		md.setVoPropertyName("lblGridCompanyCode");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_COMPANY_CODE");
		md.setWebLabelName("DEF GRID COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("DEPT_CODE");
		md.setVoPropertyName("deptCode");
		md.setColumnTitle("DEPT_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_DEPARTMENT_DEPT_CODE");
		md.setWebLabelName("DEF DEPARTMENT DEPT CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_DEPT_CODE");
		md.setVoPropertyName("srchDeptCodeFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_DEPT_CODE");
		md.setWebLabelName("DEF SRCH DEPT CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_DEPT_CODE");
		md.setVoPropertyName("srchDeptCodeTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_DEPT_CODE");
		md.setWebLabelName("DEF SRCH DEPT CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_DEPT_CODE");
		md.setVoPropertyName("lblGridDeptCode");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_DEPT_CODE");
		md.setWebLabelName("DEF GRID DEPT CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("DEPT_NAME");
		md.setVoPropertyName("hdrDeptName");
		md.setColumnTitle("DEPT_NAME");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(200);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(200);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_DEPARTMENT_DEPT_NAME");
		md.setWebLabelName("DEF DEPARTMENT DEPT NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_DEPT_NAME");
		md.setVoPropertyName("srchHdrDeptNameFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_DEPT_NAME");
		md.setWebLabelName("DEF SRCH DEPT NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_DEPT_NAME");
		md.setVoPropertyName("srchHdrDeptNameTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_DEPT_NAME");
		md.setWebLabelName("DEF SRCH DEPT NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_DEPT_NAME");
		md.setVoPropertyName("lblGridHdrDeptName");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_DEPT_NAME");
		md.setWebLabelName("DEF GRID DEPT NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("STATUS");
		md.setVoPropertyName("hdrStatus");
		md.setColumnTitle("STATUS");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DEPARTMENT_STATUS");
		md.setWebLabelName("DEF DEPARTMENT STATUS");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_STATUS");
		md.setVoPropertyName("srchHdrStatus");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_STATUS");
		md.setWebLabelName("DEF SRCH STATUS");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_STATUS");
		md.setVoPropertyName("srchHdrStatus");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_STATUS");
		md.setWebLabelName("DEF SRCH STATUS");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_STATUS");
		md.setVoPropertyName("lblGridHdrStatus");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_STATUS");
		md.setWebLabelName("DEF GRID STATUS");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("GROUP_CODE");
		md.setVoPropertyName("hdrGroupCode");
		md.setColumnTitle("GROUP_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DEPARTMENT_GROUP_CODE");
		md.setWebLabelName("DEF DEPARTMENT GROUP CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_GROUP_CODE");
		md.setVoPropertyName("srchHdrGroupCodeFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_GROUP_CODE");
		md.setWebLabelName("DEF SRCH GROUP CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_GROUP_CODE");
		md.setVoPropertyName("srchHdrGroupCodeTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_GROUP_CODE");
		md.setWebLabelName("DEF SRCH GROUP CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_GROUP_CODE");
		md.setVoPropertyName("lblGridHdrGroupCode");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_GROUP_CODE");
		md.setWebLabelName("DEF GRID GROUP CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("BRAND_CODE");
		md.setVoPropertyName("hdrBrandCode");
		md.setColumnTitle("BRAND_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DEPARTMENT_BRAND_CODE");
		md.setWebLabelName("DEF DEPARTMENT BRAND CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_BRAND_CODE");
		md.setVoPropertyName("srchHdrBrandCodeFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_BRAND_CODE");
		md.setWebLabelName("DEF SRCH BRAND CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_BRAND_CODE");
		md.setVoPropertyName("srchHdrBrandCodeTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_BRAND_CODE");
		md.setWebLabelName("DEF SRCH BRAND CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_BRAND_CODE");
		md.setVoPropertyName("lblGridHdrBrandCode");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_BRAND_CODE");
		md.setWebLabelName("DEF GRID BRAND CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("CUST_CODE");
		md.setVoPropertyName("hdrCustCode");
		md.setColumnTitle("CUST_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DEPARTMENT_CUST_CODE");
		md.setWebLabelName("DEF DEPARTMENT CUST CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_CUST_CODE");
		md.setVoPropertyName("srchHdrCustCodeFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_CUST_CODE");
		md.setWebLabelName("DEF SRCH CUST CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_CUST_CODE");
		md.setVoPropertyName("srchHdrCustCodeTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_CUST_CODE");
		md.setWebLabelName("DEF SRCH CUST CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_CUST_CODE");
		md.setVoPropertyName("lblGridHdrCustCode");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_CUST_CODE");
		md.setWebLabelName("DEF GRID CUST CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("DIVISION_CODE");
		md.setVoPropertyName("hdrDivisionCode");
		md.setColumnTitle("DIVISION_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DEPARTMENT_DIVISION_CODE");
		md.setWebLabelName("DEF DEPARTMENT DIVISION CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_DIVISION_CODE");
		md.setVoPropertyName("srchHdrDivisionCodeFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_DIVISION_CODE");
		md.setWebLabelName("DEF SRCH DIVISION CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_DIVISION_CODE");
		md.setVoPropertyName("srchHdrDivisionCodeTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_DIVISION_CODE");
		md.setWebLabelName("DEF SRCH DIVISION CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_DIVISION_CODE");
		md.setVoPropertyName("lblGridHdrDivisionCode");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_DIVISION_CODE");
		md.setWebLabelName("DEF GRID DIVISION CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("OUTLET");
		md.setVoPropertyName("hdrOutlet");
		md.setColumnTitle("OUTLET");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DEPARTMENT_OUTLET");
		md.setWebLabelName("DEF DEPARTMENT OUTLET");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_OUTLET");
		md.setVoPropertyName("srchHdrOutletFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_OUTLET");
		md.setWebLabelName("DEF SRCH OUTLET");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_OUTLET");
		md.setVoPropertyName("srchHdrOutletTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_OUTLET");
		md.setWebLabelName("DEF SRCH OUTLET");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_OUTLET");
		md.setVoPropertyName("lblGridHdrOutlet");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_OUTLET");
		md.setWebLabelName("DEF GRID OUTLET");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("IS_US");
		md.setVoPropertyName("hdrIsUs");
		md.setColumnTitle("IS_US");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DEPARTMENT_IS_US");
		md.setWebLabelName("DEF DEPARTMENT IS US");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_IS_US");
		md.setVoPropertyName("srchHdrIsUsFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_IS_US");
		md.setWebLabelName("DEF SRCH IS US");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_IS_US");
		md.setVoPropertyName("srchHdrIsUsTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_IS_US");
		md.setWebLabelName("DEF SRCH IS US");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_IS_US");
		md.setVoPropertyName("lblGridHdrIsUs");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_IS_US");
		md.setWebLabelName("DEF GRID IS US");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("IS_MERCHANDISING_DEPARTMENT");
		md.setVoPropertyName("hdrIsMerchandisingDepartment");
		md.setColumnTitle("IS_MERCHANDISING_DEPARTMENT");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DEPARTMENT_IS_MERCHANDISING_DEPARTMENT");
		md.setWebLabelName("DEF DEPARTMENT IS MERCHANDISING DEPARTMENT");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_IS_MERCHANDISING_DEPARTMENT");
		md.setVoPropertyName("srchHdrIsMerchandisingDepartmentFr");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_IS_MERCHANDISING_DEPARTMENT");
		md.setWebLabelName("DEF SRCH IS MERCHANDISING DEPARTMENT");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_IS_MERCHANDISING_DEPARTMENT");
		md.setVoPropertyName("srchHdrIsMerchandisingDepartmentTo");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_IS_MERCHANDISING_DEPARTMENT");
		md.setWebLabelName("DEF SRCH IS MERCHANDISING DEPARTMENT");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_IS_MERCHANDISING_DEPARTMENT");
		md.setVoPropertyName("lblGridHdrIsMerchandisingDepartment");
		md.setColumnClassName("java.lang.String");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_IS_MERCHANDISING_DEPARTMENT");
		md.setWebLabelName("DEF GRID IS MERCHANDISING DEPARTMENT");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("CREATE_USER");
		md.setVoPropertyName("createUser");
		md.setColumnTitle("CREATE_USER");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DEPARTMENT_CREATE_USER");
		md.setWebLabelName("DEF DEPARTMENT CREATE USER");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("CREATE_DATE");
		md.setVoPropertyName("createDate");
		md.setColumnTitle("CREATE_DATE");
		md.setColumnTypeName("DATE");
		md.setColumnType(91);
		md.setColumnSize(15);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.sql.Timestamp");
		md.setColumnPrecision(0);
		md.setColumnScale(0);
		md.setDisplaySize(15);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DEPARTMENT_CREATE_DATE");
		md.setWebLabelName("DEF DEPARTMENT CREATE DATE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("UPDATE_USER");
		md.setVoPropertyName("updateUser");
		md.setColumnTitle("UPDATE_USER");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DEPARTMENT_UPDATE_USER");
		md.setWebLabelName("DEF DEPARTMENT UPDATE USER");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("UPDATE_DATE");
		md.setVoPropertyName("updateDate");
		md.setColumnTitle("UPDATE_DATE");
		md.setColumnTypeName("DATE");
		md.setColumnType(91);
		md.setColumnSize(15);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.sql.Timestamp");
		md.setColumnPrecision(0);
		md.setColumnScale(0);
		md.setDisplaySize(15);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_DEPARTMENT_UPDATE_DATE");
		md.setWebLabelName("DEF DEPARTMENT UPDATE DATE");
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_DEPARTMENT_SELECT");
		md.setWebLabelName("DEF DEPARTMENT SELECT");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_DEPARTMENT_DELETE");
		md.setWebLabelName("DEF DEPARTMENT DELETE");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_SEARCH_MOD_NAME");
		md.setWebLabelName("DEF SEARCH MOD NAME");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_MAINT_MOD_NAME");
		md.setWebLabelName("DEF MAINT MOD NAME");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_TAB_DEPARTMENT");
		md.setWebLabelName("LBL_TAB_DEPARTMENT");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_SRCH_FROM");
		md.setWebLabelName("DEF SRCH FROM");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_SRCH_TO");
		md.setWebLabelName("DEF SRCH TO");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		new DeptCommonSchema().setMoreSchema();
	}

}